package com.xmy.cultivate.mapper;

import com.xmy.cultivate.entity.GradeModule;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 面试评分模块表 Mapper 接口
 * </p>
 *
 * @author hpiggy
 * @since 2024-11-28
 */
public interface GradeModuleMapper extends BaseMapper<GradeModule> {


    @Select({"<script>",
            "SELECT * FROM adms_grade_module WHERE deleted = 0 AND status = 1 AND FIND_IN_SET(${type}, type) ORDER BY sort " ,

            "</script>"})

    public List<GradeModule> getModulesByType(@Param("type") String type);

}
